Role: Informatica Developer
Location : Horsham , PA
Duration : Long TermClient is looking advanced Informatica features like normalization, partition, recovery and performance options. Below I have given roles more on Informatica Powercenter which client would be expecting.
• ETL Performance tuning and Optimization techniques and able to handle huge volume of data
• Extensively worked on Informatica tools Repository manager, Designer, Work-flow manager, Work-flow monitor.
• Hands on Oracle SQL PLSQL, expertise in writing complex queries, built-in Oracle tools ( Data pump)
• Created mappings using the transformations like Source qualifier, SQL, Aggregator, Expression, look-up, Router, Filter, Update Strategy, Joiner, Stored procedure and etc. transformations.
• Involve in creating Deployment groups by creating both Static and Dynamic deployment for each mapping and do deployment of mapping from DEV to SIT and to UAT and PROD Respectively.
• Healthcare domain experience and handling data (claims, product, member) is an added advantage
• Experience on Informatica TDM/ILM is an added advantage
• Java knowledge will be Nice to have for this role.
Role: Tibco/PowerBuilder Developer
Location : Addison , TX
Duration : Long term
Hands-on experience on PowerBuilder version 12.5.
• Design, build and configure applications to meet business process and application requirements
• Sound knowledge in PowerBuilder 125 objects, ex: Window, user objects visual and nonvisual, data window, data store, etc
• Good analytical and troubleshooting skills
• Hands-on experience on Sybase database.
• Excellent in writing medium to complex SQL statements, stored procedures and performance tuning.
• Able to interact with customers independently on all requirements.
• Required Skills
• - PowerBuilder 12.5
• Good to have skills(Optional):
- Unix, C Shell scripting
- Dot Net
- TIBCO
Role: Tableau Developer
Location : Philadelphia, PA
Duration : Long Term
Tableau Job description
• Has solid Experience with the Tableau and SAS
• Strong hands on experience in Dashboard design using Tableau.
• Experience with transformation of reports from SAS to Tableau.
• Good knowledge on SQL and troubleshooting skills.
• Should be able to perform BSA to do deep dive tier 3 analysis looking specifically at in Database comparison skills for the two different data base tables based on the requirement.
• Health care knowledge is advantageous.
• Associate will work on support of applications/processes and to provide daily status to the customer.
• Good communication skills and connect with customer daily.
Role: BigData Engineer
Location : Atlanta, GA
Duration : Long Term
Sr Data Engineer - HadoopThe Sr Data Engineer position will be responsible for evaluating, designing and developing technical solutions within the technology functions of the company in accordance with the policies and practices of Anthem. Also this position will be responsible for hands-on development of various current and new data warehouse initiatives while maintaining the exceptional level of professionalism and customer service standards that Anthem has attained within the healthcare industry.
The Data Engineer should possess the following Qualifications:
PRIMARY DUTIES and RESPONSIBILITIES:
• Make ongoing recommendations of solution standards and system configurations
• Work in cross-disciplinary teams to understand client needs and ingest rich data sources.
• Research, experiment, and utilize leading Big Data technologies in AWS
• Enabling an innovative approach to data platforms which greatly increase the flexibility, scalability, and reliability of IT services at a lower cost
• Leading design reviews, planning , developing and resolving technical issues
• Delivering highly complex solution & Design using in-depth knowledge within the business domain
• Design data warehouses on platforms such as AWS Redshift, , Hadoop and other high performance platforms
• Design custom ETL processes based on customer needs and their existing data sources
• Optimize data warehouses for performance
• Contribute to the core design of data architecture, data models and schemas, and implementation plans
• Understand the practicalities of DevOps style (agile/lean) approaches to software development.
• Assist in technical presentations and info-sharing sessions to create a clear and uniform understanding of the new systems to various constituents within
• Provide guidance and lead resolution of technical issues as they arise.
• At times, responsible for assisting with client and project engagements to document technical requirements for database, applications, integration, infrastructure, etc.
• Develops and owns list of final enhancements, also performs technical design reviews and code reviews.
Qualifications:
• Bachelor’s degree in information technology, computer science, or related field required
• 5+ years of experience with data technologies including Hadoop(Cloudera) , HBase, Spark, Hive, RedShift etc.,
• Strong experience with data integration technologies including Apache NiFi (or similar tools)
• 5+ years of experience in developing and maintain ETL processes
• Knowledge of Oracle, SQL Server and Tableau high preferred
• Experience implementing solutions on the Public Cloud , AWS preferred
• Experience using AWS native tools (S3, EBS, EC2, EMR) preferred
• Experience building applications with Dev Ops tools such as Bamboo, Bitbucket, Artifactory etc. is preferred
• 5+ years of experience with NoSQL implementation (Mongo) a plus
• Experience designing and implementing Healthcare applications
• Experience with security and privacy standards; e.g. HIPAA, HITRUST, ISO27001 etc.,
• Excellent Written, verbal, and diagrammatic communication skills
• Demonstrated ability to interface effectively and collaborate with clients, peers, and management to develop solutions and ensure stakeholder buy-in.
• Experience in Agile software development life cycles and DevOps principles
Role: SQL/SSIS Developer
Location : Sunrise, FL
Duration : Long Term
• Required skill MS SQL Server, SSIS and SSRS
• Strong SSIS, SSRS and MS SQL Server Developer with experience in application Development\application Support
• Strong knowledge of SQL Server Stored procedure development and maintenance
• Good knowledge in SQL Server performance tuning, profiling, SQL query tuning, indexes etc.,
• Associate must have a strong leadership quality and should have experience on executing onsite and offshore model
• Previous ETL experience work is a very strong point that we would be looking for.
• Ability to analyze and troubleshoot SSIS ETL packages and SSRS reports and fix issues
• Must have good communication in order to liaise with the customer stakeholders. Work closely with Client SME's and understand the requirements
• Must have worked on complex design and should be able to process data within quick time
• Should have good technical skills , communication and Analytical skills with excellent creative and conceptual thinking abilities.
• Should be hands on in analyzing the performance of the queries and fine tuning.
• Required to work in application support environment.
• Troubleshooting current production SSIS packages, SSRS reports and SQL Server procedures as need.
• Knowledge of HealthCare domain will be an additional plus.
• We are looking for high end As for this to take up some critical positions.
• Ability to work “flextime” to attend scheduled meetings off hours to interact with offshore teams.
--