Blog

Title: GA DHS – Sr. Analytics Power BI Developer

Contract: W2 AND C2C

Location: 47 Trinity Ave SW, Atlanta, GA 30334

Duration: Long Term

• ·Expertise and solid experience in BI Tools – Power BI and BigQuery
• ·Strong IDMC(Informatica) technical knowledge in the design, development, and management of complex Informatica mappings, sessions, and workflows
• ·Strong programming skills, relational database skills with expertise in Advanced SQL and PL/SQL, indexing, and query tuning
• ·Experienced in Business Intelligence and Data warehousing concepts and methodologies.
• Contribute to the design and implementation of the solution's metadata, ETL, and reporting components, including testing and, at times, deployment.
• ·Extensive experience in data and root cause analysis and proven problem-solving and analytical thinking capabilities.
• ·Analytical capabilities to slice and dice data and display data in reports for the best user experience.
• ·Demonstrated ability to review and translate business processes into BI reporting and analysis solutions.
• ·Ability to follow the Software Development Lifecycle (SDLC) process and should be able to work under any project management methodologies used.
• ·Ability to follow best practices and standards.
• ·Ability to identify and tune BI application performance bottlenecks.
• ·Ability to work quickly and accurately under pressure and project time constraints
• ·Abilityto prioritize workload and work with minimal supervision
• ·Basic understanding of software engineering principles and skills working on Unix/Linux/Windows Operating systems, Version Control, and Office software
• ·Exposure Data Modeling using Star/Snowflake Schema Design, Data Marts, Relational and Dimensional Data Modeling, Slowly Changing Dimensions, Fact and Dimensional tables, Physical and Logical data modeling
• Produce client deliverables such as detailed design documentation, configuration documentation, unit test plans, and training curriculum

Required Qualifications:

• A bachelor's degree in computer science or a related field
• 6 to 7 years of experience working with Power BI, IDMC, and BigQuery
• Ability to design and develop complex Informatica mappings, sessions, and workflows and identify areas of optimizations
• Experience with Oracle RDBMS 19c
• Effective communication skills (both oral and written) and the ability to work effectively in a team environment are required.
• Proven ability and desire to mentor/coach others in a team environment
• Strong analytical, problem-solving, and presentation skills.

Preferred Qualifications:

• Working knowledge of Informatica Power Exchange/Power Center and IDMC
• Experience with relational, multidimensional, and OLAP techniques and technology
• Experience with Visualization tools like MS Power BI, Tableau
• Experience with BigQuery.